﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Grain.Crm.ExcelExtractor.Input;

namespace Grain.Crm.ExcelExtractor.InputDescription.Sheets
{
    public class SkillsSheetDescription : SheetDescription
    {
        public int SkillsStartedAtRow;
        public string IgnoreSkillLevelvalue;
        public string IgnoreSkillMonthsvalue;

        public void Build()
        {
            this.SheetName = "Skills";

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Skill", CrmDisplayName = "Skill", Column = 3, Row = -1 });
            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Skill Area",  CrmDisplayName = "Skill Area", Column = 1, Row = -1 });
            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Skills Sub-Area", CrmDisplayName = "Skills Sub-Area", Column = 2, Row = -1 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "SkillLevel", Column = 4, Row = -1 });
            this.Descriptions.Add(new ValueDescription() { XlsDescription = "SkillExpYears", Column = 5, Row = -1 });

            IgnoreSkillLevelvalue = "Level";
            IgnoreSkillMonthsvalue = "Experience in years";
            SkillsStartedAtRow = 5;
        }
    }
}
